--------------------------------------------------------
--  DDL for Table APPLICATION
--------------------------------------------------------
  CREATE TABLE "APPLICATION" 
   (	"APPLICATION_KEY" VARCHAR2(36 BYTE), 
	"NAME" VARCHAR2(256 BYTE), 
	"CREATED_UTC" DATE, 
	"MODIFIED_UTC_DATE" DATE, 
	"DESCRIPTION" VARCHAR2(256 BYTE)
   ) ;

   COMMENT ON COLUMN "APPLICATION"."APPLICATION_KEY" IS 'Application key (guid)';
   COMMENT ON COLUMN "APPLICATION"."NAME" IS 'Application name';
   COMMENT ON COLUMN "APPLICATION"."CREATED_UTC" IS 'Created date';
   COMMENT ON COLUMN "APPLICATION"."MODIFIED_UTC_DATE" IS 'Modified date';
   COMMENT ON COLUMN "APPLICATION"."DESCRIPTION" IS 'Descriptipn';
--------------------------------------------------------
--  DDL for Index APPLICATION_PK
--------------------------------------------------------
  CREATE UNIQUE INDEX "APPLICATION_PK" ON "APPLICATION" ("APPLICATION_KEY")  ;

--------------------------------------------------------
--  Constraints for Table APPLICATION
--------------------------------------------------------
  ALTER TABLE "APPLICATION" ADD CONSTRAINT "APPLICATION_PK" PRIMARY KEY ("APPLICATION_KEY");

  ALTER TABLE "APPLICATION" MODIFY ("NAME" NOT NULL ENABLE);
  ALTER TABLE "APPLICATION" MODIFY ("APPLICATION_KEY" NOT NULL ENABLE);
